USE [ANTS_NetServer]
GO

/****** Object:  StoredProcedure [dbo].[proc_userInfo_update]    Script Date: 04/21/2013 15:28:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[proc_userInfo_update]
(
	@username nvarchar(50),
	@pwd nvarchar(50),
	@registerDate datetime,
    @email nvarchar(50),
    @qq nvarchar(50),
    @tel nvarchar(50),
    @purview int
)as 
update [userInfo] set
	[pwd]=@pwd,
    [regDate]=@registerDate,
    [email] = @email,
    [qq] = @qq,tel = @tel,
    [purview] = @purview
WHERE
	[username]=@username


GO

